Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_LOGMNR_PURGED_LOG

`DBA_LOGMNR_PURGED_LOG` displays archived redo log files that have been applied to the logical standby database and can be deleted because they are no longer needed. FIles in this view are refreshed as a result of executing either of the following PL/SQL procedures:

- `DBMS_LOGSTDBY.PURGE_SESSION` (for Oracle Data Guard SQL Apply)

- `DBMS_CAPTURE.SET_FIRST_SCN` (for Oracle Streams)

Column | Datatype | NULL | Description
--- | --- | --- | ---
`FILE_NAME` | `VARCHAR2(513)` |  | Fully qualified names of the archived redo log files that are no longer needed by SQL Apply and can be deleted from the operating system